﻿CREATE PROCEDURE [dbo].[proc_ManagementArea_Create]
	(
	 @CompanyName nvarchar(50),
	 @Startletter nvarchar(50),
	 @CompanyNumber nvarchar(50),
	 @CompanyPhone nvarchar(50),
	 @CompanyFax nvarchar(50),
	 @CompanyAddress nvarchar(100),
	 @Zip nvarchar(10),
	 @ContactPerson nvarchar(20),
	 @ContactPhone nvarchar(20),
	 @ContactEmail nvarchar(50),
	 @WebAddress nvarchar(50),
	 @Products nvarchar(2000)
	)
AS
	begin 
	SET NOCOUNT ON;

		Insert Into ManagementArea(CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,ContactPerson,ContactPhone,ContactEmail,WebAddress,Products)
		Values(@CompanyName,@Startletter,@CompanyNumber,@CompanyPhone,@CompanyFax,@CompanyAddress,@Zip,@ContactPerson,@ContactPhone,@ContactEmail,@WebAddress,@Products)
	
-- 徐福龙 @ 2012 03 24 EDIT
		Select isnull(@@Identity ,0) as 'RETUNR_V'

	end
	RETURN
